<?php
 include("include/textcenter.php");
 include("include/db.php");
 $id = $_GET["id"];


$result = mysql_query("SELECT  cp.*, p.Product, c.admin_title FROM vnf_category_product cp 
left join vnf_category c on cp.CategoryID = c.category_id
left join vnf_product p on cp.ProductID = p.ProductNo where CPID ='$id'");
while($row = mysql_fetch_array($result))
{
$category = $row['CategoryID'];
$product = $row['ProductID'];
$producttitle = $row['Product'];
$categorytitle = $row['admin_title'];
}
mysql_close($con);
 ?>
<html>
<head>
<meta name="description" content="Admin<?php echo $tagdescription?>">
<meta name="keywords" content="<?php echo $tagkeywords?> Main">
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title><?php echo $tagtitle?></title>

<script type="text/javascript" src="simpletreemenu.js">
/***********************************************
* Simple Tree Menu- © Dynamic Drive DHTML code library (www.dynamicdrive.com)
* This notice MUST stay intact for legal use
* Visit Dynamic Drive at http://www.dynamicdrive.com/ for full source code
***********************************************/
</script>
<link rel="stylesheet" type="text/css" href="simpletree.css" />
<LINK rel="StyleSheet" href="include/css_classes.css" type="text/css">

</head>



<body topmargin="0" leftmargin="0" marginwidth="0" marginheight="0" link="#0000FF" vlink="#800080" alink="#FF0000" bgcolor="#FFFFFF">
<!-- -------------------Header---------------------------- -->
<?php include("include/header.php"); ?>
<!-- -------------------End Header---------------------------- -->


<div align="center">
<table border="0" cellspacing="0" cellpadding="0">
	<tr>
		<td width="12%" valign="top">
		<img border="0" src="public/images/homepage/spider16.gif" width="200" height="1"></td>
		<td width="1%" valign="top">
		<img border="0" src="public/images/homepage/spider16.gif" width="16" height="1"></td>
		<td width="86%" valign="top">
		<img border="0" src="public/images/homepage/spider16.gif" width="16" height="1"></td>
	</tr>	
	<tr>
		<!-- ///////////////////Begin Leftmenu/////////////////// -->
		<td width="12%" valign="top" bgcolor="#FFFFFF">
		<?php include("include/leftmenu.php"); ?>
		</td>
		<!-- ///////////////////End Leftmenu/////////////////// -->
		
		<td width="1%" valign="top" background="public/images/homepage/16.gif">&nbsp;</td>
		<td width="86%" valign="top">
	<br>
<!-- -------------------Begin Body---------------------------- -->
<p class="title16B">&nbsp;<a href="category_product_list.php">Detail Category - Product</a> </p>
<table border="1" width="50%" cellspacing="0" cellpadding="2" bordercolor="#FFECFF">
    <tr>
        <td width="90px" ></td>
        <td width="80px"><b style="color: gray;">ID</b></td>
        <td><b style="color: gray;">Name</b></td>
    </tr>
	<tr>
		<td width="90px" valign="top"><b style="color: gray;">Category</b></td>
		<td valign="top"><b style="color: #F9F;"><?php echo $category?></b></td>
        <td><b style="color: #F9F;"><?php echo $categorytitle?></b> </td>
	</tr>
	<tr>
		<td valign="top"><b style="color: gray;">ProductNo</b></td>
		<td valign="top"><b style="color: #F9F;"><?php echo $product?></b></td>
        <td><b style="color: #F9F;"><?php echo $producttitle?></b></td>
	</tr>
    <tr>
        <td></td>
        <td colspan="2"><a href="category_product_update.php?id=<?php echo $id ?>">Update</a>
        &nbsp;&nbsp;<a href="category_product_list.php?id=<?php echo $id ?>">Back</a>
        </td>
    </tr>
</table>
<!-- -------------------End Body---------------------------- -->

&nbsp;</td>
	</tr>

</table>
</div>
<!-- ----------------------------------------------- -->
<!-- \\\\\\\\\\\\\\\\\\\\\Begin Footer\\\\\\\\\\\\\\\\\\\\\ -->
<?php include("include/footer.php"); ?>
<!-- \\\\\\\\\\\\\\\\\\\\\End Footer\\\\\\\\\\\\\\\\\\\\\ -->
</body>

</html>